create database MyImage_Bank
go
use MyImage_Bank
go
create table Account
(
AccountID varchar(15),
Balance float
)
go
-- create procedure spInsertNewAccount
create procedure spInsertNewAccount
@username varchar(15)
as
	begin
		insert into Account values(@username, 1000000)
	end
go
--create procedure spGetAccountBalance
create procedure spGetAccountBalance
@username varchar(15)
as
	begin
		select * from Account where AccountID = @username
	end
go
-- create procedure spUpdateBalance
create procedure spUpdateBalance
@username varchar(15),
@bala float
as
	begin
		Update Account SET Balance = @bala Where AccountID = @username
	end
	
	
	